IQA Queries

The Intelligent Query Architect (IQA) is the foundation for searches, lists, and data for reporting throughout iMIS.

Understanding IQA  PAGEREF _Toc329869263 \h 1

Key Features: IQA  2

Task by role: IQA  2

Understanding iMIS queries 3

Tour: Intelligent Query Architect 4

Concepts and Terms: IQA  4

Administering IQA  4

Building a library of queries 5

Administering security for IQA  6

Integrating queries throughout iMIS  6

Building Queries  7

Creating or editing a query (Basic mode) 9

Query examples using Basic mode  11

Editing query-generated lists in iMIS  17

Defining displays for users 18

Finding customer records with IQA  18

Defining a query (Advanced mode) 19

Developing filters 20

Limiting the rows returned by a query  21

Defining a filter property with several values 21

Adding dynamic filters to queries 22

Linking IQA results 23

Hierarchical grid display  26

Query examples using Advanced mode  27

Reporting in IQA  40

Creating and saving IQA reports 42

Printing IQA reports 43

Subtotaling and ordering IQA reports 44

Global layout control for IQA reports 45

Creating links to reports in the Document System  46

Using IQA  47

Icons 47

Running queries 47

Accessing module based reports 48